﻿CREATE TABLE [dbo].[CHITIETHOADON] (
    [MaHD]     VARCHAR (10) NOT NULL,
    [MaDoUong] VARCHAR (10) NOT NULL,
    [SoLuong]  INT          NULL,
    [GiaTien]  FLOAT (53)   NULL,
    PRIMARY KEY CLUSTERED ([MaHD] ASC, [MaDoUong] ASC),
    FOREIGN KEY ([MaDoUong]) REFERENCES [dbo].[DANHMUCDOUONG] ([MaDoUong]),
    FOREIGN KEY ([MaHD]) REFERENCES [dbo].[HOADON] ([MaHD])
);

